﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using System.Data.SqlClient;
using DAL.Entities;

namespace DAL.Entities_DAL
{
    public class CTPMT_DAL:BaseDAL
    {

        public DataTable Select_ct(string id, DateTime ngay, string loai, string maphong, string matb)
        {
            string sql = @" set dateformat dmy;
                            SELECT *
                            FROM CT_PMT
                            WHERE MA_PMT = '{0}' AND NGAY_LAP = '{1}' AND LOAI_PHIEU = '{2}' AND MA_PHONG = '{3}' AND MA_TB = '{4}'
                            ";
            sql = string.Format(sql, id, ngay, loai, maphong, matb);
            return ExecuteQuery(sql);
        }
    }
}
